home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
CD ROM Paradise Collection 4
/
CD ROM Paradise Collection 4 1995 Nov.iso
/
win
/
vbsmpls.zip
/
SAMPLES
/
SETOBJNM
/
ABSTRACT.TXT
next >
Wrap
Text File
|
1994-03-24
|
1KB
|
27 lines
SetObjNm: A Single Function that Changes Object Names in Microsoft« Excel
SETOBJNM.XLA is a simple but useful example of an add-in. Its purpose is to
make it easy to change the default name of a graphic object, such as a button
on a dialog sheet, from "Button 2" to "cmdOK" or whatever your coding
standards dictate. On installation, the add-in puts a toolbar button on the
Forms toolbar, with the ToolTip text "Set Object Name." Selecting a graphic
object and clicking the Set Object Name button displays the default name of
the object and allows you to change it.
The source file, SETOBJNM.XLS, demonstrates:
* Installing and uninstalling an add-in.
* Searching a collection.
* Displaying a simple dialog box.
* Using object navigation paths to add a ToolbarButton
object to a Toolbar object.
* Storing and setting toolbar button faces.
* Setting ToolTip text for a toolbar button.
A second workbook, SETOBJN1.XLS, contains code from the EditBox reference
section of Chapter 4, "Microsoft Excel Objects," in Programming Integrated
Solutions with Microsoft Office. It demonstrates the same functionality as
the add-in, but uses an uncompiled workbook.
SetObjNm incorporates the functionality of Microsoft Excel version 5.0.